Click on the filter operator box (next to the column box) and select contains
item from the dropdown list which displaying all available filter operators.
You can choose Custom from the list to enter the condition manually.
Filter Operator
|
Result
|
begins with <?> | My_Field LIKE 'your_value%' |
contains <?> | My_Field LIKE '%your_value%' |
does not contain <?> | NOT (My_Field LIKE '%your_value%') |
ends with <?> | My_Field LIKE '%your_value' |
is between <?> <?> | ((My_Field >= your_value1) and (My_Field <= your_value2)) |
is blank | My_Field = '' |
is equal to <?> | My_Field = 'your_value' |
is greater than <?> | My_Field > 'your_value' |
is greater than or equal to <?> | My_Field >= 'your_value' |
is less than <?> | My_Field < 'your_value' |
is less than or equal to <?> | My_Field <= 'your_value' |
is not between <?> <?> | NOT ((My_Field >= your_value1) and (My_Field <= your_value2)) |
is not blank | My_Field <> '' |
is not equal to <?> | My_Field <> 'your_value' |
is not null | My_Field IS NOT NULL |
is null | My_Field IS NULL |